# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月13日
"""
import pandas as pd

path = '../数据文件/课件026/分组聚合.xlsx'
data = pd.read_excel(path, index_col='城市')

data2 = data.groupby(len).sum()

# print(data)
print(data2)